Mobility Data Report

Overview

Dataset statistics

Number of records 37340
Distinct trips 18670
Number of complete trips (start and and point) 18670
Number of incomplete trips (single point) 0
Distinct users 182
Distinct locations (lat & lon combination) 35485

Additional variable

Missing values

User ID (uid) 0
Trip ID (tid) 0
Timestamp (datetime) 0
Latitude (lat) 0
Longitude (lng) 0

Temporal properties

Number of trips over time


Distribution

Min. 2000-01-02
25% 2008-10-06
Median 2009-02-21
75% 2009-08-01
Max. 2012-07-27

Number of trips per weekday

Number of trips per hour of day split by weekday and weekend

Place analysis

Visits per tile

TODO: fix bug that all legends appear in first map

Points outside the given tessellation: 3583
The following statistics give insights into the distribution of the visits over the tiles (mean, min, max and quartiles) - whether there are tiles that are visited more often than others or if the visits are distributed equally over all tiles.

Distribution

Min. 0.0
25% 0.0
Median 0.0
75% 3.0
Max. 4854.0
A different way of visualizing the distribution of visits over tiles is achieved by the cumuluated sum of all visits: If only a few tiles include most of all visits, the curve has a steep increase in the beginning and a flat part at the end. If the visits are distributed equally over the entire tiles the line is a straight diagonal.

Ranking most frequently visited tiles

1 385 (Id: 385): 4854.0
2 477 (Id: 477): 3052.0
3 265 (Id: 265): 1813.0
4 533 (Id: 533): 1780.0
5 165 (Id: 165): 1760.0
6 8 (Id: 8): 1638.0
7 364 (Id: 364): 1581.0
8 214 (Id: 214): 1032.0
9 678 (Id: 678): 914.0
10 360 (Id: 360): 710.0

Visits per tile and time window

Weekday: absolute count

Weekday: deviation from average

Weekend: absolute count

Weekend: deviation from average

Origin-destination (OD) analysis

OD flows between tiles

Intra-tile flows

The number and percentage of flows that start and end within the same tile.

4018.0 (24.24 %) of flows start and end within the same cell.

A large number of intra-cell flows either indicate round-trips (e.g., going running starting and ending at the home location) or a tessellation that is to coarse to properly capture flows.

Distribution

Mean 6.22
Min. 1.0
25% 1.0
Median 1.0
75% 2.0
Max. 593.0
A different way of visualizing the distribution of number per flows is achieved by the cumuluated sum of all flows: If only a few flows include most of all visits, the curve has a steep increase in the beginning and a flat part at the end. If the visits are distributed equally over the entire flows the line is a straight diagonal.

Most frequent OD connections

Ranking most frequent OD connections

1 385 - 385: 593.0
2 477 - 477: 392.0
3 364 - 364: 391.0
4 8 - 8: 366.0
5 477 - 477: 324.0
6 265 - 265: 319.0
7 533 - 533: 299.0
8 265 - 265: 292.0
9 214 - 214: 256.0
10 533 - 533: 252.0

Trip statistics

Travel time of trips (in minutes)

5166 outliers have been excluded.
Outliers are values above 90

Distribution

Min. 0.0
25% 12.0
Median 22.0
75% 40.0
Max. 90.0

Jump length (in kilometers)

45 outliers have been excluded.
Outliers are values above 30

Distribution

Min. 0.0
25% 0.62
Median 2.23
75% 8.05
Max. 29.95

User analysis

number of trajectories per user

Distribution

Min. 1.0
25% 8.0
Median 27.5
75% 89.75
Max. 2153.0

Time between two consecutive trajectories of a user

How much time passes between two consecutive trajeoctories? This information gives insights on the temporal density of the dataset. Trajectories might follow each other consecutively, then the time inbetween only is as long as the stay duration at that place. If the trips are only collected sparsely there might be days between single trajectories of a user.
This analysis is based on the assumption that trips of a user follow each other consecutively and do not overlap, i.e., the start time of a following trip cannot start before the previous one has ended. Therefore, we first perform a plausibility check to ensure that no user trips overlap. Otherwise this might be an indication for a faulty dataset.

Plausibility check: overlapping user trips

There are 0 cases where the start time of the following trajectory precedes the previous end time.
If there are overlapping trips present in the dataset the minimum time between trajectories will be negative.

Distribution

Min. 0 days 00:00:01
25% 0 days 06:29:09.750000
Median 0 days 11:11:02
75% 0 days 16:28:57.250000
Max. 2657 days 11:05:53

Radius of gyration (in kilometers)

The radius of gyration is the characteristic distance traveled by an individual during a period of time.
95 outliers have been excluded.
Outliers are values above 30

Distribution

Min. 0.09
25% 2.0
Median 5.12
75% 7.13
Max. 14.74

Location entropy

Location entropy (based on Shannon Entropy) captures the diversity of user visits. If most trips to a certain location originate from a single (or few) user the entropy is low. A high entropy suggests that the place is visited by diverse users evenly. A dataset with many cells with high visit counts but low entropy suggests, that single users drive certain mobility patterns that might not be representative for other users.

Number of distinct tiles per user

How many different tiles does a single user visit?

Distribution

Min. 0.0
25% 4.0
Median 7.5
75% 16.0
Max. 196.0

Mobility Entropy

The temporal-uncorrelated entropy characterizes the heterogeneity of the users visitation patterns (including the historical probability that a location was visited by the user).

Distribution

Min. 0.0
25% 0.55
Median 0.68
75% 0.81
Max. 1.0